{ "cells": [ { "cell_type": "markdown", "id": "57a92274", "metadata": {}, "source": [ "# Interconnection Queues" ] }, { "cell_type": "code", "execution_count": 1, "id": "3599dfce", "metadata": {}, "outputs": [], "source": [ "import gridstatus\n", "import pandas as pd\n", "import plotly.express as px" ] }, { "cell_type": "markdown", "id": "82965289", "metadata": {}, "source": [ "## NYISO Interconnection Queue\n", "\n", "The `get_interconnection_queue` call returns projects that are \"active\", \"completed\", and \"withdrawn\"" ] }, { "cell_type": "code", "execution_count": 2, "id": "5e62d100", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Queue IDProject NameInterconnecting EntityCountyStateInterconnection LocationTransmission OwnerGeneration TypeCapacity (MW)Summer Capacity (MW)...Withdrawn DateWithdrawal CommentActual Completion DateProposed In-ServiceProposed Initial-Sync DateLast Updated DateZSAvailability of StudiesSGIA Tender Date
00276Homer Solar Energy CenterNaNCortlandNYNaNNM-NGSolar90.090.0...NaNNaNNaNNaT2023-09-019/30/2022C10.0FES, SRIS, FSNaN
10393Berrians East ReplacementNaNQueensNYNaNCONEDDual Fuel94.294.2...NaNNaNNaNNaT2024-08-016/30/2022J11.0FES, SRIS, FSNaN
20396Baron WindsNaNSteubenNYNaNNYSEGWind238.4238.4...NaNNaNNaNNaT2022-11-2912/31/2022C13.0FES, SRIS, FSNaN
30396AWood Street TransformerNaNPutnamNYNaNNYSEGAC Transmission0.0NaN...NaNNaNNaNNaTNaT4/30/2021G12.0SISNaN
40422Eight Point Wind Energy CenterNaNSteuben-AlleganyNYNaNNYSEGWind101.8101.8...NaNNaNNaNNaT2022-11-013/31/2021C12.0FES, SRIS, FSNaN
\n", "

5 rows × 24 columns

\n", "
" ], "text/plain": [ " Queue ID Project Name Interconnecting Entity \\\n", "0 0276 Homer Solar Energy Center NaN \n", "1 0393 Berrians East Replacement NaN \n", "2 0396 Baron Winds NaN \n", "3 0396A Wood Street Transformer NaN \n", "4 0422 Eight Point Wind Energy Center NaN \n", "\n", " County State Interconnection Location Transmission Owner \\\n", "0 Cortland NY NaN NM-NG \n", "1 Queens NY NaN CONED \n", "2 Steuben NY NaN NYSEG \n", "3 Putnam NY NaN NYSEG \n", "4 Steuben-Allegany NY NaN NYSEG \n", "\n", " Generation Type Capacity (MW) Summer Capacity (MW) ... Withdrawn Date \\\n", "0 Solar 90.0 90.0 ... NaN \n", "1 Dual Fuel 94.2 94.2 ... NaN \n", "2 Wind 238.4 238.4 ... NaN \n", "3 AC Transmission 0.0 NaN ... NaN \n", "4 Wind 101.8 101.8 ... NaN \n", "\n", " Withdrawal Comment Actual Completion Date Proposed In-Service \\\n", "0 NaN NaN NaT \n", "1 NaN NaN NaT \n", "2 NaN NaN NaT \n", "3 NaN NaN NaT \n", "4 NaN NaN NaT \n", "\n", " Proposed Initial-Sync Date Last Updated Date Z S \\\n", "0 2023-09-01 9/30/2022 C 10.0 \n", "1 2024-08-01 6/30/2022 J 11.0 \n", "2 2022-11-29 12/31/2022 C 13.0 \n", "3 NaT 4/30/2021 G 12.0 \n", "4 2022-11-01 3/31/2021 C 12.0 \n", "\n", " Availability of Studies SGIA Tender Date \n", "0 FES, SRIS, FS NaN \n", "1 FES, SRIS, FS NaN \n", "2 FES, SRIS, FS NaN \n", "3 SIS NaN \n", "4 FES, SRIS, FS NaN \n", "\n", "[5 rows x 24 columns]" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "iso = gridstatus.NYISO()\n", "queue = iso.get_interconnection_queue()\n", "queue.head()" ] }, { "cell_type": "code", "execution_count": 3, "id": "4b9a440a", "metadata": {}, "outputs": [ { "data": { "image/svg+xml": "WithdrawnActiveCompleted0100200300400500600700800Project by Status - NYISOindexStatus" }, "metadata": {}, "output_type": "display_data" } ], "source": [ "status_distributions = queue[\"Status\"].value_counts()\n", "fig = px.bar(\n", " status_distributions,\n", " x=status_distributions.index,\n", " y=\"Status\",\n", " title=\"Project by Status - NYISO\",\n", ")\n", "fig.show(\"svg\")" ] }, { "cell_type": "markdown", "id": "831647bc", "metadata": {}, "source": [ "## Days in Queue" ] }, { "cell_type": "code", "execution_count": 4, "id": "dd3179bf", "metadata": { "tags": [] }, "outputs": [ { "data": { "image/svg+xml": "01000200030004000500001020304050607080Days in Queue - Active Projects - NYISODays in Queuecount" }, "metadata": {}, "output_type": "display_data" } ], "source": [ "queue[\"Days in Queue\"] = (pd.Timestamp.now() - queue[\"Queue Date\"]).dt.days\n", "active = queue[queue[\"Status\"] == \"Active\"]\n", "fig = px.histogram(\n", " active, x=\"Days in Queue\", title=\"Days in Queue - Active Projects - NYISO\"\n", ")\n", "fig.show(\"svg\")" ] }, { "cell_type": "markdown", "id": "09af99f7", "metadata": {}, "source": [ "## Top Active Project Types" ] }, { "cell_type": "code", "execution_count": 5, "id": "53eceb78", "metadata": {}, "outputs": [ { "data": { "image/svg+xml": "SolarEnergy StorageWindAC TransmissionDC TransmissionLoadCombined CycleDual FuelCombustion Turbine050100150Project by Type - NYISOindexGeneration Type" }, "metadata": {}, "output_type": "display_data" } ], "source": [ "generation_types = active[\"Generation Type\"].value_counts()\n", "fig = px.bar(\n", " generation_types,\n", " x=generation_types.index,\n", " y=\"Generation Type\",\n", " title=\"Project by Type - NYISO\",\n", ")\n", "fig.show(\"svg\")" ] }, { "cell_type": "markdown", "id": "a5d6e271", "metadata": {}, "source": [ "## Proposed Completion Date" ] }, { "cell_type": "code", "execution_count": 6, "id": "5810554d", "metadata": {}, "outputs": [ { "data": { "image/svg+xml": "202420262028203001020304050607080Generation TypeSolarDual FuelWindAC TransmissionDC TransmissionEnergy StorageLoadCombined CycleCombustion TurbineProposed Completion Date - NYISOProposed Completion Datecount" }, "metadata": {}, "output_type": "display_data" } ], "source": [ "fig = px.histogram(\n", " active,\n", " x=\"Proposed Completion Date\",\n", " title=\"Proposed Completion Date - NYISO\",\n", " color=\"Generation Type\",\n", ")\n", "fig.show(\"svg\")" ] }, { "cell_type": "markdown", "id": "e6e24a54", "metadata": {}, "source": [ "## Get Interconnection Queue Data from All ISOs" ] }, { "cell_type": "code", "execution_count": 7, "id": "6b124082", "metadata": {}, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "100%|██████████| 7/7 [00:22<00:00, 3.27s/it]\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ISOQueue IDProject NameInterconnecting EntityCountyStateInterconnection LocationTransmission OwnerGeneration TypeCapacity (MW)Summer Capacity (MW)Winter Capacity (MW)Queue DateStatusProposed Completion DateWithdrawn DateWithdrawal CommentActual Completion Date
0Midcontinent ISOE002NoneNonePointe CoupeeLA500 kV switchyard at Big Cajon IIEntergyGas15.00000015.015.02013-09-13T04:00:00ZDoneNoneNoneNoneNone
1Midcontinent ISOE291NoneNoneTXRich 138 kV substationEntergyHydro27.00000027.027.02012-05-15T04:00:00ZDone2016-01-31T05:00:00ZNoneNoneNone
2Midcontinent ISOG001NoneNoneBrown CountyWIUnknownAmerican Transmission Co. LLC255.000000255.0255.01995-11-08T05:00:00ZWithdrawn2014-11-17T05:00:00ZNoneNoneNone
3Midcontinent ISOG002NoneNoneTrimble CountyKYUnknownLG&E and KU Services Company as agent for Loui...Coal174.000000174.0174.01998-12-01T05:00:00ZDone2016-01-01T05:00:00ZNoneNoneNone
4Midcontinent ISOG003NoneNoneTrimble CountyKYUnknownLG&E and KU Services Company as agent for Loui...Coal174.000000174.0174.01998-12-01T05:00:00ZDone2004-01-01T05:00:00ZNoneNoneNone
.........................................................
19870ISO New England1308Uxbridge Substation – NG Hopedale West Group S...NoneWorcesterMANG Feeder 321W6, Uxbridge T2NaNBAT6.9940006.9946.9942022-09-09 00:00:00Withdrawn2024-11-15 00:00:00NaTNoneNone
19871ISO New England1310Battery StorageNoneBerkshireMA115 kV Transmission line (1211 - Present betwe...NaNBAT118.750000118.75118.752022-09-22 00:00:00Withdrawn2025-09-30 00:00:00NaTNoneNone
19872ISO New England1314Offshore WindNoneNaNMAEversource 115kV Acushnet, lines 112/114NaNWND470.000000470.0470.02022-09-26 00:00:00Withdrawn2029-09-01 00:00:00NaTNoneNone
19873ISO New England1315Battery StorageNoneWindhamCTEversource Killingly Substation,115kV BUS, Tra...NaNBAT106.970001106.970001106.9700012022-09-28 00:00:00Withdrawn2026-06-09 00:00:00NaTNoneNone
19874ISO New England1316Solar plus BatteryNoneCheshireNHEversource 115kV line L163NaNSUN BAT102.000000102.0102.02022-09-30 00:00:00Withdrawn2027-10-28 00:00:00NaTNoneNone
\n", "

19875 rows × 18 columns

\n", "
" ], "text/plain": [ " ISO Queue ID \\\n", "0 Midcontinent ISO E002 \n", "1 Midcontinent ISO E291 \n", "2 Midcontinent ISO G001 \n", "3 Midcontinent ISO G002 \n", "4 Midcontinent ISO G003 \n", "... ... ... \n", "19870 ISO New England 1308 \n", "19871 ISO New England 1310 \n", "19872 ISO New England 1314 \n", "19873 ISO New England 1315 \n", "19874 ISO New England 1316 \n", "\n", " Project Name \\\n", "0 None \n", "1 None \n", "2 None \n", "3 None \n", "4 None \n", "... ... \n", "19870 Uxbridge Substation – NG Hopedale West Group S... \n", "19871 Battery Storage \n", "19872 Offshore Wind \n", "19873 Battery Storage \n", "19874 Solar plus Battery \n", "\n", " Interconnecting Entity County State \\\n", "0 None Pointe Coupee LA \n", "1 None TX \n", "2 None Brown County WI \n", "3 None Trimble County KY \n", "4 None Trimble County KY \n", "... ... ... ... \n", "19870 None Worcester MA \n", "19871 None Berkshire MA \n", "19872 None NaN MA \n", "19873 None Windham CT \n", "19874 None Cheshire NH \n", "\n", " Interconnection Location \\\n", "0 500 kV switchyard at Big Cajon II \n", "1 Rich 138 kV substation \n", "2 Unknown \n", "3 Unknown \n", "4 Unknown \n", "... ... \n", "19870 NG Feeder 321W6, Uxbridge T2 \n", "19871 115 kV Transmission line (1211 - Present betwe... \n", "19872 Eversource 115kV Acushnet, lines 112/114 \n", "19873 Eversource Killingly Substation,115kV BUS, Tra... \n", "19874 Eversource 115kV line L163 \n", "\n", " Transmission Owner Generation Type \\\n", "0 Entergy Gas \n", "1 Entergy Hydro \n", "2 American Transmission Co. LLC \n", "3 LG&E and KU Services Company as agent for Loui... Coal \n", "4 LG&E and KU Services Company as agent for Loui... Coal \n", "... ... ... \n", "19870 NaN BAT \n", "19871 NaN BAT \n", "19872 NaN WND \n", "19873 NaN BAT \n", "19874 NaN SUN BAT \n", "\n", " Capacity (MW) Summer Capacity (MW) Winter Capacity (MW) \\\n", "0 15.000000 15.0 15.0 \n", "1 27.000000 27.0 27.0 \n", "2 255.000000 255.0 255.0 \n", "3 174.000000 174.0 174.0 \n", "4 174.000000 174.0 174.0 \n", "... ... ... ... \n", "19870 6.994000 6.994 6.994 \n", "19871 118.750000 118.75 118.75 \n", "19872 470.000000 470.0 470.0 \n", "19873 106.970001 106.970001 106.970001 \n", "19874 102.000000 102.0 102.0 \n", "\n", " Queue Date Status Proposed Completion Date \\\n", "0 2013-09-13T04:00:00Z Done None \n", "1 2012-05-15T04:00:00Z Done 2016-01-31T05:00:00Z \n", "2 1995-11-08T05:00:00Z Withdrawn 2014-11-17T05:00:00Z \n", "3 1998-12-01T05:00:00Z Done 2016-01-01T05:00:00Z \n", "4 1998-12-01T05:00:00Z Done 2004-01-01T05:00:00Z \n", "... ... ... ... \n", "19870 2022-09-09 00:00:00 Withdrawn 2024-11-15 00:00:00 \n", "19871 2022-09-22 00:00:00 Withdrawn 2025-09-30 00:00:00 \n", "19872 2022-09-26 00:00:00 Withdrawn 2029-09-01 00:00:00 \n", "19873 2022-09-28 00:00:00 Withdrawn 2026-06-09 00:00:00 \n", "19874 2022-09-30 00:00:00 Withdrawn 2027-10-28 00:00:00 \n", "\n", " Withdrawn Date Withdrawal Comment Actual Completion Date \n", "0 None None None \n", "1 None None None \n", "2 None None None \n", "3 None None None \n", "4 None None None \n", "... ... ... ... \n", "19870 NaT None None \n", "19871 NaT None None \n", "19872 NaT None None \n", "19873 NaT None None \n", "19874 NaT None None \n", "\n", "[19875 rows x 18 columns]" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "all_queues = gridstatus.get_interconnection_queues()\n", "all_queues" ] }, { "cell_type": "code", "execution_count": 8, "id": "5c40fb33", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Withdrawn 7464\n", "Active 6624\n", "WITHDRAWN 1606\n", "In Service 1031\n", "Done 763\n", "Completed 758\n", "ACTIVE 470\n", "Engineering and Procurement 322\n", "Confirmed 223\n", "COMPLETED 199\n", "Retracted 131\n", "Suspended 78\n", "Deactivated 57\n", "Partially in Service - Under Construction 55\n", "Under Construction 53\n", "Annulled 24\n", "Withdrawn - Pending Cure 2\n", " 1\n", "Name: Status, dtype: int64" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "all_queues[\"Status\"].value_counts()" ] }, { "cell_type": "markdown", "id": "55660a55", "metadata": {}, "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3.10.2 64-bit ('gridstatus')", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.10.2" }, "vscode": { "interpreter": { "hash": "49f14642123d0cc1afa9fa45716ed5f1e915189c28b01efe02a8b7ec3c0a3fce" } } }, "nbformat": 4, "nbformat_minor": 5 }